{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Revenue Report","Phone Call Report","Calculate","Data Sheet","Graphs","Help ","Past Reports","Past Graphs"],"not_rendered":{"charts":48,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Revenue Report","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[13,7,13,9],[479,1,479,4],[9,1,9,3]]}
[]
[]
["Revenue Report",null,null,"Quarter 1"]
["Fit Life Chiropractic",null,"2017-03-26"]
["Parkdale Plaza"]
["4119 Staples Street, Suite 230",null,"Name"]
["Corpus Christi, TX 78411",null,"Dr. David Nelson"]
["(361) 371-7100 "]
[]
[]
[]
[]
[null,"(MM/DD/YYYY)","AP/WI","RP/NP","BB/RA/SI/PR/WA/OA","###.##"]
[null,"Date","Appointment or Walk-in","Category","Description","Amount",null,"Key for Reporting"]
[null,"2018-01-02","WI","NP","SI",350,null,"NP= New Patient"]
[null,"2018-01-05","WI","NP","SI",500,null,"RP = Returning Patient"]
[null,"2018-01-03","AP","NP","WA",650,null,"PR = Patient Referal"]
[null,"2018-01-12","AP","RP","BB",560,null,"OA = Other Advertisement "]
[null,"2018-01-13","AP","NP","RA",200,null,"SI = Store sign "]
[null,"2018-01-22","WI","NP","BB",200,null,"RA = Radio Advertisment"]
[null,"2018-01-30","WI","RP","SI",33,null,"BB = Bilboard"]
[null,"2018-01-31","WI","NP","WA",223,null,"WA = Web Advertisemt"]
[null,"2018-02-01","WI","RP","PR",234,null,"PE = Public Events"]
[null,"2018-02-08","AP","NP","SI",150,null,"AP = Appointment"]
[null,"2018-03-15","WI","RP","PR",203,null,"WI = Walk in"]
[null,"2018-03-20","AP","RP","PE",343]
[null,"2018-04-15","AP","NP","PE",232]
[null,"2018-05-15","AP","RP","RA",232]
[null,"2018-05-20","AP","RP","SI",865]

{"sheet":"Phone Call Report","index":1,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Phone Call Tracker"]
[null,"Week of ","Week Number","Web calls","Radio ad calls","Other Calls","Total calls"]
["Quarter 1","2018-01-01",1,0,0,0,{"$f":"SUM(D3:F3)","v":0}]
[null,"2017-04-02",2,0,0,0,{"$f":"SUM(D4:F4)","v":0}]
[null,"2017-04-09",3,0,0,0,0]
[null,"2017-04-16",4,0,0,0,0]
[null,"2017-04-23",5,1,0,0,1]
[null,"2017-04-30",6,0,0,0,0]
[null,"2017-04-30",7,1,0,0,1]
[null,"2018-02-19",8,1,0,0,1]
[null,"2018-02-26",9,3,0,0,3]
[null,"2018-03-05",10,3,0,0,3]
[null,"2018-03-12",11,2,0,0,2]
[null,"2018-03-19",12,0,0,0,0]
[null,"2018-03-26",13,7,0,0,7]
[]
["Quarter 2","2018-04-02",1,2,0,0,2]
[null,"2018-04-09",2,2,0,0,2]
[null,"2018-04-16",3,2,0,0,2]
[null,"2018-04-23",4,2,0,0,2]
[null,"2018-04-30",5,0,0,0,0]
[null,"2018-05-07",6,0,0,0,0]
[null,"2018-05-14",7,3,0,0,3]
[null,"2018-05-21",8,2,0,0,2]
[null,"2018-05-28",9,0,0,0,0]
[null,"2018-06-04",10,0,0,0,0]
[null,"2018-06-11",11,0,0,0,0]
[null,"2018-06-18",12,1,0,0,1]
[null,"2018-06-25",13,1,0,0,1]
[]
["Quarter 3","2018-07-02",1,0,0,0,0]
[null,"2018-07-09",2,0,0,0,0]
[null,"2018-07-16",3,0,0,0,0]
[null,"2018-07-23",4,0,0,0,0]
[null,"2018-07-30",5,1,0,0,1]
[null,"2018-08-06",6,1,0,0,1]
[null,"2018-08-13",7,0,0,0,0]
[null,"2018-08-20",8,0,0,0,0]
[null,"2018-08-27",9,0,0,0,0]
[null,"2018-09-03",10,0,0,0,0]
[null,"2018-09-10",11,2,2,0,4]
[null,"2018-09-17",12,0,0,0,0]
[null,"2018-09-24",13,0,0,0,0]
[]
["Quarter 4","2018-10-01",1,0,1,0,1]
[null,"2018-10-08",2,0,0,0,0]
[null,"2018-10-15",3,0,0,0,0]
[null,"2018-10-22",4,1,0,0,1]
[null,"2018-10-29",5,3,6,2,11]
[null,"2018-11-05",6,null,null,null,0]
[null,"2018-11-12",7,null,null,null,0]
[null,"2018-11-19",8,null,null,null,0]
[null,"2018-11-26",9,null,null,null,0]
[null,"2018-12-03",10,null,null,null,0]
[null,"2018-12-10",11,null,null,null,0]
[null,"2018-12-17",12,null,null,null,0]
[null,"2018-12-24",13,null,null,null,0]

{"sheet":"Calculate","index":2,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,5],[15,1,15,2],[15,3,15,5],[16,1,16,2],[13,1,13,2],[13,3,13,5],[16,3,16,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Email for Reports",null,"horton.188@gmail.com",null,null,null,null,"chris.gold@goldcrm.com"]
[null,"Name",null,"Chris"]
[]
[null,"Email for Updates",null,"horton.188@gmail.com"]
[null,"Name",null,"Spencer"]

{"sheet":"Data Sheet","index":3,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,4],[0,5,0,8],[0,9,0,12],[0,13,0,19]]}
["Time Information",null,null,"General ",null,"Phone Calls",null,null,null,"Type of Patient",null,null,null,"Source of New Patients"]
["Quarter 1","Date","Week","Visits","Revenue","Total","Web","Radio","Other","Walk in","Appointment","Returning Patients","New Patients","Web ad.","Public event","Patient referral","Other ad.","Sign","Radio Ad.","Billboard"]
[null,"2018-01-01",1,3,1500,0,0,0,0,2,1,0,3,1,0,0,0,2,0,0]
[null,"2018-01-08",2,2,760,0,0,0,0,0,2,1,1,0,0,0,0,0,1,1]
[null,"2018-01-15",3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-01-22",4,1,200,0,0,0,0,1,0,0,1,0,0,0,0,0,0,1]
[null,"2018-01-29",5,3,490,1,1,0,0,3,1,2,2,1,0,1,0,1,0,0]
[null,"2018-02-05",6,1,150,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0]
[null,"2018-02-12",7,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-02-19",8,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-02-26",9,0,0,3,3,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-03-05",10,0,0,3,3,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-03-12",11,1,203,2,2,0,0,1,1,1,0,0,0,1,0,0,0,0]
[null,"2018-03-19",12,1,343,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0]
[null,"2018-03-26",13,0,0,7,7,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Quarter 2","Date","Week","Visit","Revenue","Total","Web","Radio","Other","Walk In","Appointment","Returning Patinets","New Patients","Web Ad.","Public Event","Patient Referral","Other Ad.","Sign","Radio Ad.","Billboard"]
[null,"2018-04-02",16,0,0,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-04-09",17,1,232,2,2,0,0,0,1,0,0,0,1,0,0,0,0,0]
[null,"2018-04-16",18,0,0,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-04-23",19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-04-30",20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-05-07",21,0,0,3,3,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2018-05-14",22,2,1097,2,2,0,0,0,2,2,0,0,0,0,0,1,1,0]

{"sheet":"Graphs","index":4,"n_rows":61,"n_cols":1,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Quarter 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarter 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarter 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarter 4"]

{"sheet":"Help ","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Past Reports","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,1,9,3],[479,1,479,4],[12,6,12,9]]}
[]
[]
["Revenue Report",null,null,"All Time"]
["Fit Life Chiropractic",null,"2017-03-26"]
["Parkdale Plaza"]
["4119 Staples Street, Suite 230",null,"Name"]
["Corpus Christi, TX 78411",null,"Dr. David Nelson"]
["(361) 371-7100 "]
[]
[]
[]
[]
[null,null,null,null,null,null,"Calls"]
[null,"Date","Apoint.","Return.","Source","Amount","Web","Radio","Other ","Total "]

{"sheet":"Past Graphs","index":7,"n_rows":61,"n_cols":1,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Quarter 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarter 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarter 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quarter 4"]